CREATE TABLE parsename_Employee_before_14_11_or_15_6 (
 EmployeeID INT PRIMARY KEY,
 FirstName NVARCHAR(50),
 LastName NVARCHAR(50),
 HireDate DATETIME,
 Salary MONEY
);
GO


-- Insert some sample data
INSERT INTO parsename_Employee_before_14_11_or_15_6(EmployeeID, FirstName, LastName, HireDate, Salary)
VALUES (1, 'John', 'Doe', '2020-01-01', 50000),
 (2, 'Jane', 'Smith', '2020-02-01', 60000),
 (3, 'Bob', 'Johnson', '2020-03-01', 70000);
GO

CREATE VIEW parsename_EmployeeDatabaseView1_before_14_11_or_15_6
AS
SELECT PARSENAME('tempdb.dbo.Employee', 3) AS [Database Name]
GO

CREATE PROCEDURE parsename_GetEmployeeDatabaseName1_before_14_11_or_15_6
AS
BEGIN
 SELECT PARSENAME('tempdb.dbo.Employee', 3) AS [Database Name]
END
GO

CREATE VIEW parsename_EmployeeDatabaseView2_before_14_11_or_15_6
AS
SELECT PARSENAME('tempdb.dbo.Employee', 2) AS [Schema Name]
GO

CREATE PROCEDURE parsename_GetEmployeeDatabaseName2_before_14_11_or_15_6
AS
BEGIN
 SELECT PARSENAME('tempdb.dbo.Employee', 2) AS [Schema Name]
END
GO

CREATE VIEW parsename_EmployeeDatabaseView3_before_14_11_or_15_6
AS
SELECT PARSENAME('tempdb.dbo.Employee', 1) AS [Table Name]
GO

CREATE PROCEDURE parsename_GetEmployeeDatabaseName3_before_14_11_or_15_6
AS
BEGIN
SELECT PARSENAME('tempdb.dbo.Employee_parsename', 1) AS [Table Name]
END
GO